Tabela PersonHospInformed

Definicja tabeli PersonHospInformed

Name

PersonHospInformed

Code

PersonHospInformed

Comment

Tabela przechowujaca historie udzielania informaji o pobycie (kto, komu, kiedy, o jakim pobycie).


Lista kolumn tabeli PersonHospInformed

Name

Code

EventID

EventID

PersonID

PersonID

Per_PersonID

Per_PersonID

StartDT

StartDT

InsertingPersonID

InsertingPersonID

InsertDT

InsertDT

Info

Info


Kolumna EventID tabeli PersonHospInformed

Definicja kolumny EventID tabeli PersonHospInformed

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli PersonHospInformed

Definicja kolumny PersonID tabeli PersonHospInformed

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Per_PersonID tabeli PersonHospInformed

Definicja kolumny Per_PersonID tabeli PersonHospInformed

Name

Per_PersonID

Code

Per_PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli PersonHospInformed

Definicja kolumny StartDT tabeli PersonHospInformed

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna InsertingPersonID tabeli PersonHospInformed

Definicja kolumny InsertingPersonID tabeli PersonHospInformed

Name

InsertingPersonID

Code

InsertingPersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDT tabeli PersonHospInformed

Definicja kolumny InsertDT tabeli PersonHospInformed

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna Info tabeli PersonHospInformed

Definicja kolumny Info tabeli PersonHospInformed

Name

Info

Code

Info

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Info